Columns
Grants
Dependencies
Details
Triggers
Errors
Columns
Grants
Dependencies
Details
Triggers
Errors
COLUMN_NAME | DATA_TYPE | NULLABLE | DATA_DEFAULT | COLUMN_ID | COMMENTS | INSERTABLE | UPDATABLE | DELETABLE |
---|---|---|---|---|---|---|---|---|
DAYS_TO_CLOSED | NUMBER(38) | Yes | null | 22 | null | NO | NO | NO |
SID | NUMBER | No | null | 1 | null | NO | NO | NO |
OBJ | VARCHAR2(20) | No | null | 2 | null | NO | NO | NO |
ID | VARCHAR2(100) | No | null | 3 | null | NO | NO | NO |
TITLE | VARCHAR2(100) | No | null | 4 | null | NO | NO | NO |
ALLEGATION_CATEGORY | VARCHAR2(200) | Yes | null | 5 | null | NO | NO | NO |
ALLEGATION_SUBCATEGORY | VARCHAR2(200) | Yes | null | 6 | null | NO | NO | NO |
CASE_DISPOSITION | VARCHAR2(4000) | Yes | null | 7 | null | NO | NO | NO |
SUBJECT_ID | VARCHAR2(4000) | Yes | null | 8 | null | NO | NO | NO |
STATUS | VARCHAR2(100) | Yes | null | 9 | null | NO | NO | NO |
OPEN_DATE | DATE | Yes | null | 10 | null | NO | NO | NO |
CLOSED_DATE | DATE | Yes | null | 11 | null | NO | NO | NO |
INV_CLOSED_DATE | DATE | Yes | null | 12 | null | NO | NO | NO |
LEAD_PERSONNEL | VARCHAR2(400) | Yes | null | 13 | null | NO | NO | NO |
SUPPORT_PERSONNEL | VARCHAR2(4000) | Yes | null | 14 | null | NO | NO | NO |
FINAL_DUE_DATE | DATE | Yes | null | 15 | null | NO | NO | NO |
CREATED_DATE | DATE | Yes | null | 16 | null | NO | NO | NO |
CREATED_ON_FY | NUMBER | Yes | null | 17 | null | NO | NO | NO |
DAYS_TO_AWAIT_APPROVAL | NUMBER(38) | Yes | null | 18 | null | NO | NO | NO |
DAYS_TO_OPEN | NUMBER(38) | Yes | null | 19 | null | NO | NO | NO |
DAYS_TO_AWAIT_EMP_REVIEW | NUMBER(38) | Yes | null | 20 | null | NO | NO | NO |
DAYS_TO_INV_CLOSED | NUMBER(38) | Yes | null | 21 | null | NO | NO | NO |
PRIVILEGE | GRANTEE | GRANTABLE | GRANTOR | OBJECT_NAME |
---|
OWNER | NAME | TYPE | REFERENCED_OWNER | REFERENCED_NAME | REFERENCED_TYPE |
---|
References
NAME | VALUE |
---|---|
CREATED | 23-AUG-24 |
LAST_DDL_TIME | 07-FEB-25 |
OWNER | QART |
VIEW_NAME | V_CUBE_TIMES_INVESTIGATIONS |
TEXT_LENGTH | 5247 |
TEXT | SELECT DISTINCT I.SID, I.OBJ, I.ID, I.SUBJECT TITLE, C.DISPLAY ALLEGATION_CATEGORY, SC.DISPLAY ALLEGATION_SUBCATEGORY, IR.DISPLAY CASE_DISPOSITION, SUB.SUBJECTS SUBJECT_ID, STAT1.STATUS, TRUNC(STAT2.STARTED_ON) OPEN_DATE, TRUNC(STAT3.STARTED_ON) CLOSED_DATE, TRUNC(STAT4.STARTED_ON) INV_CLOSED_DATE, SH1.SH_DISPLAY LEAD_PERSONNEL, SH2.SH_DISPLAY SUPPORT_PERSONNEL, O.FINAL_DUE_DATE, O.CREATED_ON CREATED_DATE, O.CREATED_ON_FY, (TRUNC(NVL(STAT6.STARTED_ON, SYSDATE)) - TRUNC(NVL(STAT5.STARTED_ON, SYSDATE))) DAYS_TO_AWAIT_APPROVAL, (TRUNC(NVL(STAT7.STARTED_ON, SYSDATE)) - TRUNC(NVL(STAT6.STARTED_ON, SYSDATE))) DAYS_TO_OPEN, (TRUNC(NVL(STAT8.STARTED_ON, SYSDATE)) - TRUNC(NVL(STAT7.STARTED_ON, SYSDATE))) DAYS_TO_AWAIT_EMP_REVIEW, (TRUNC(NVL(STAT9.STARTED_ON, SYSDATE)) - TRUNC(NVL(STAT8.STARTED_ON, SYSDATE))) DAYS_TO_INV_CLOSED, (TRUNC(NVL(STAT10.STARTED_ON, SYSDATE)) - TRUNC(NVL(STAT9.STARTED_ON, SYSDATE))) DAYS_TO_CLOSED FROM MV_F_INFORMATION I INNER JOIN MV_ACM_OBJ O ON I.OBJ = O.SID INNER JOIN MV_ACM_OBJ_TYPE OT ON O.OBJ_TYPE = OT.SID AND OT.OBJ_TYPE_CODE != 'FILE.COLL_INV' LEFT JOIN MV_INCIDENT_CATEGORIES SC ON I.INCIDENT = SC.SID LEFT JOIN MV_INCIDENT_CATEGORIES C ON SC.PARENT_CATEGORY = C.SID LEFT JOIN MV_CONTRIBUTING_FACTORS F ON I.CONTRIBUTING_FACTOR = F.SID LEFT JOIN MV_F_INFORMATION_REF IR ON I.DISPOSITION = IR.REF_KEY LEFT JOIN (SELECT DISTINCT OBJ, LISTAGG (PARTIC_OBJ, ';' || CHR (13)) WITHIN GROUP (ORDER BY PARTIC_OBJ) OVER (PARTITION BY OBJ) AS SUBJECTS, LISTAGG(OFFICE,';' || CHR (13)) WITHIN GROUP ( ORDER BY PARTIC_OBJ ) OVER (PARTITION BY OBJ) AS OFFICE FROM V_OBJ_PARTICIPANTS WHERE CODE = 'SUBJECT') SUB ON I.OBJ = SUB.OBJ LEFT JOIN (SELECT DISTINCT OBJ, LISTAGG (PARTIC_DISPLAY, ';' || CHR (13)) WITHIN GROUP (ORDER BY PARTIC_DISPLAY) OVER (PARTITION BY OBJ) AS OWNING_AGENCY FROM V_OBJ_PARTICIPANTS WHERE CODE = 'OWNING_AGENCY') OA ON I.OBJ = OA.OBJ LEFT JOIN V_OBJ_STATUS_HISTORY STAT1 ON I.OBJ = STAT1.OBJ AND STAT1.COMPLETED_ON IS NULL LEFT JOIN ( SELECT OBJ, MIN (STARTED_ON) STARTED_ON, MIN (STARTED_ON_FY) STARTED_ON_FY FROM V_OBJ_STATUS_HISTORY WHERE CODE = 'OPEN' GROUP BY OBJ) STAT2 ON I.OBJ = STAT2.OBJ LEFT JOIN V_OBJ_STATUS_HISTORY STAT3 ON I.OBJ = STAT3.OBJ AND STAT3.CODE LIKE 'CLOSED' LEFT JOIN ( SELECT OBJ, MIN (STARTED_ON) STARTED_ON, MIN (STARTED_ON_FY) STARTED_ON_FY FROM V_OBJ_STATUS_HISTORY WHERE CODE = 'INV_CLOSED' GROUP BY OBJ) STAT4 ON I.OBJ = STAT4.OBJ LEFT JOIN (SELECT OBJ, MIN(STARTED_ON) STARTED_ON FROM V_OBJ_STATUS_HISTORY WHERE CODE = 'PRELIM_INVEST' GROUP BY OBJ) STAT5 ON I.OBJ = STAT5.OBJ LEFT JOIN (SELECT OBJ, MIN(STARTED_ON) STARTED_ON FROM V_OBJ_STATUS_HISTORY WHERE CODE = 'APPROVAL' GROUP BY OBJ) STAT6 ON I.OBJ = STAT6.OBJ LEFT JOIN (SELECT OBJ, MIN(STARTED_ON) STARTED_ON FROM V_OBJ_STATUS_HISTORY WHERE CODE = 'OPEN' GROUP BY OBJ) STAT7 ON I.OBJ = STAT7.OBJ LEFT JOIN (SELECT OBJ, MIN(STARTED_ON) STARTED_ON FROM V_OBJ_STATUS_HISTORY WHERE CODE = 'EMP_SPRVSR_REVIEW' GROUP BY OBJ) STAT8 ON I.OBJ = STAT8.OBJ LEFT JOIN (SELECT OBJ, MIN(STARTED_ON) STARTED_ON FROM V_OBJ_STATUS_HISTORY WHERE CODE = 'INV_CLOSED' GROUP BY OBJ) STAT9 ON I.OBJ = STAT9.OBJ LEFT JOIN (SELECT OBJ, MIN(STARTED_ON) STARTED_ON FROM V_OBJ_STATUS_HISTORY WHERE CODE = 'CLOSED' GROUP BY OBJ) STAT10 ON I.OBJ = STAT10.OBJ LEFT JOIN V_CURR_OBJ_STAKEHOLDERS SH1 ON I.OBJ = SH1.OBJ AND SH1.CODE = 'LEAD' LEFT JOIN (SELECT DISTINCT OBJ, LISTAGG (SH_DISPLAY, ';' || CHR (13)) WITHIN GROUP (ORDER BY SH_DISPLAY) OVER (PARTITION BY OBJ) AS SH_DISPLAY FROM V_CURR_OBJ_STAKEHOLDERS WHERE CODE = 'SUPPORT') SH2 ON I.OBJ = SH2.OBJ /* SELECT OBJ, TITLE, CASE WHEN DAYS_TO_AWAIT_APPROVAL < 0 THEN NULL ELSE DAYS_TO_AWAIT_APPROVAL END DAYS_TO_AWAIT_APPROVAL, CASE WHEN DAYS_TO_OPEN < 0 THEN NULL ELSE DAYS_TO_OPEN END DAYS_TO_OPEN, CASE WHEN DAYS_TO_AWAIT_EMP_REVIEW < 0 THEN NULL ELSE DAYS_TO_AWAIT_EMP_REVIEW END DAYS_TO_AWAIT_EMP_REVIEW, CASE WHEN DAYS_TO_INV_CLOSED < 0 THEN NULL ELSE DAYS_TO_INV_CLOSED END DAYS_TO_INV_CLOSED, CASE WHEN DAYS_TO_CLOSED < 0 THEN NULL ELSE DAYS_TO_CLOSED END DAYS_TO_CLOSED FROM STATUS_DAYS; */ |
TEXT_VC | SELECT DISTINCT I.SID, I.OBJ, I.ID, I.SUBJECT TITLE, C.DISPLAY ALLEGATION_CATEGORY, SC.DISPLAY ALLEGATION_SUBCATEGORY, IR.DISPLAY CASE_DISPOSITION, SUB.SUBJECTS SUBJECT_ID, STAT1.STATUS, TRUNC(STAT2.STARTED_ON) OPEN_DATE, TRUNC(STAT3.STARTED_ON) CLOSED_DATE, TRUNC(STAT4.STARTED_ON) INV_CLOSED_DATE, SH1.SH_DISPLAY LEAD_PERSONNEL, SH2.SH_DISPLAY SUPPORT_PERSONNEL, O.FINAL_DUE_DATE, O.CREATED_ON CREATED_DATE, O.CREATED_ON_FY, (TRUNC(NVL(STAT6.STARTED_ON, SYSDATE)) - TRUNC(NVL(STAT5.STARTED_ON, SYSDATE))) DAYS_TO_AWAIT_APPROVAL, (TRUNC(NVL(STAT7.STARTED_ON, SYSDATE)) - TRUNC(NVL(STAT6.STARTED_ON, SYSDATE))) DAYS_TO_OPEN, (TRUNC(NVL(STAT8.STARTED_ON, SYSDATE)) - TRUNC(NVL(STAT7.STARTED_ON, SYSDATE))) DAYS_TO_AWAIT_EMP_REVIEW, (TRUNC(NVL(STAT9.STARTED_ON, SYSDATE)) - TRUNC(NVL(STAT8.STARTED_ON, SYSDATE))) DAYS_TO_INV_CLOSED, (TRUNC(NVL(STAT10.STARTED_ON, SYSDATE)) - TRUNC(NVL(STAT9.STARTED_ON, SYSDATE))) DAYS_TO_CLOSED FROM MV_F_INFORMATION I INNER JOIN MV_ACM_OBJ O ON I.OBJ = O.SID INNER JOIN MV_ACM_OBJ_TYPE OT ON O.OBJ_TYPE = OT.SID AND OT.OBJ_TYPE_CODE != 'FILE.COLL_INV' LEFT JOIN MV_INCIDENT_CATEGORIES SC ON I.INCIDENT = SC.SID LEFT JOIN MV_INCIDENT_CATEGORIES C ON SC.PARENT_CATEGORY = C.SID LEFT JOIN MV_CONTRIBUTING_FACTORS F ON I.CONTRIBUTING_FACTOR = F.SID LEFT JOIN MV_F_INFORMATION_REF IR ON I.DISPOSITION = IR.REF_KEY LEFT JOIN (SELECT DISTINCT OBJ, LISTAGG (PARTIC_OBJ, ';' || CHR (13)) WITHIN GROUP (ORDER BY PARTIC_OBJ) OVER (PARTITION BY OBJ) AS SUBJECTS, LISTAGG(OFFICE,';' || CHR (13)) WITHIN GROUP ( ORDER BY PARTIC_OBJ ) OVER (PARTITION BY OBJ) AS OFFICE FROM V_OBJ_PARTICIPANTS WHERE CODE = 'SUBJECT') SUB ON I.OBJ = SUB.OBJ LEFT JOIN (SELECT DISTINCT OBJ, LISTAGG (PARTIC_DISPLAY, ';' || CHR (13)) WITHIN GROUP (ORDER BY PARTIC_DISPLAY) OVER (PARTITION BY OBJ) AS OWNING_AGENCY FROM V_OBJ_PARTICIPANTS WHERE CODE = 'OWNING_AGENCY') OA ON I.OBJ = OA.OBJ LEFT JOIN V_OBJ_STATUS_HISTORY STAT1 ON I.OBJ = STAT1.OBJ AND STAT1.COMPLETED_ON IS NULL LEFT JOIN ( SELECT OBJ, MIN (STARTED_ON) STARTED_ON, MIN (STARTED_ON_FY) STARTED_ON_FY FROM V_OBJ_STATUS_HISTORY WHERE CODE = 'OPEN' GROUP BY OBJ) STAT2 ON I.OBJ = STAT2.OBJ LEFT JOIN V_OBJ_STATUS_HISTORY STAT3 ON I.OBJ = STAT3.OBJ AND STAT3.CODE LIKE 'CLOSED' LEFT JOIN ( SELECT OBJ, MIN (STARTED_ON) STARTED_ON, MIN (STARTED_ON_FY) STARTED_ON_FY FROM V_OBJ_STATUS_HISTORY WHERE CODE = 'INV_CLOSED' GROUP BY OBJ) STAT4 ON I.OBJ = STAT4.OBJ LEFT JOIN (SELECT OBJ, MIN(STARTED_ON) STARTED_ON FROM V_OBJ_STATUS_HISTORY WHERE CODE = 'PRELIM_INVEST' GROUP BY OBJ) STAT5 ON I.OBJ = STAT5.OBJ LEFT JOIN (SELECT OBJ, MIN(STARTED_ON) STARTED_ON FROM V_OBJ_STATUS_HISTORY WHERE CODE = 'APPROVAL' GROUP BY OBJ) STAT6 ON I.OBJ = STAT6.OBJ LEFT JOIN (SELECT OBJ, MIN(STARTED_ON) STARTED_ON FROM V_OBJ_STATUS_HISTORY WHERE CODE = 'OPEN' GROUP BY OBJ) STAT7 ON I.OBJ = STAT7.OBJ LEFT JOIN (SELECT OBJ, MIN(STARTED_ON) STARTED_ON FROM V_OBJ_STATUS_HISTORY WHERE CODE = 'EMP_SPRVSR_REVIEW' GROUP BY OBJ) STAT8 ON I.OBJ = STAT8.OBJ LEFT JOIN (SELECT OBJ, MIN(STARTED_ON) STARTED_ON FROM V_OBJ_STATUS_HISTORY WHERE CODE = 'INV_CLOSE |
TYPE_TEXT_LENGTH | null |
TYPE_TEXT | null |
OID_TEXT_LENGTH | null |
OID_TEXT | null |
VIEW_TYPE_OWNER | null |
VIEW_TYPE | null |
SUPERVIEW_NAME | null |
EDITIONING_VIEW | N |
READ_ONLY | N |
CONTAINER_DATA | N |
BEQUEATH | DEFINER |
ORIGIN_CON_ID | 16 |
DEFAULT_COLLATION | USING_NLS_COMP |
CONTAINERS_DEFAULT | NO |
CONTAINER_MAP | NO |
EXTENDED_DATA_LINK | NO |
EXTENDED_DATA_LINK_MAP | NO |
HAS_SENSITIVE_COLUMN | NO |
ADMIT_NULL | NO |
PDB_LOCAL_ONLY | NO |
DUPLICATED | N |
SHARDED | N |
OWNER | TRIGGER_NAME | TRIGGER_TYPE | TRIGGERING_EVENT | STATUS | OBJECT_ID |
---|
ATTRIBUTE | Line:Position | TEXT |
---|